We are seeking an experienced Data Migration Engineer to support a Federal client in migrating enterprise data platforms from Snowflake to AWS Cloud services. The ideal candidate will have strong hands-on experience with Snowflake data extraction, AWS data lake and analytics services, and secure data migration methodologies aligned with Federal compliance standards.
This role involves designing, executing, and validating large-scale data migrations while ensuring data integrity, security, performance, and compliance with Federal regulations.
Key Responsibilities
Design and implement end-to-end data migration strategies from Snowflake to AWS cloud platforms
Extract data from Snowflake using COPY INTO, Snowflake stages, and secure data sharing mechanisms
Migrate data to AWS services including Amazon S3, Redshift, Athena, RDS/Aurora, and Glue Data Catalog
Develop and optimize data pipelines using AWS Glue, Lambda, Step Functions, and Python
Perform data validation, reconciliation, and quality checks post-migration
Convert Snowflake schemas, tables, views, and data types to AWS-compatible formats
Implement incremental and batch migration strategies using Snowflake Streams and Tasks
Ensure compliance with Federal security and data governance standards (FedRAMP, FISMA, NIST)
Optimize data formats (Parquet/ORC) for cost, performance, and scalability
Collaborate with cloud architects, security teams, and stakeholders to meet project milestones
Create technical documentation, migration runbooks, and operational guides
Monitor migration jobs and resolve performance, data consistency, or failure issues
Support post-migration testing, optimization, and production cutover activities
Take the leap to a rewarding job that pays you well and that you enjoy.
Success Stories
Habib Karbasian
Data Scientist at Neal Analytics
“I was ready to give up [on the job search point] and I was at my lowest point...fortunately,
HiCounselor was my last resort and they walked me through every step of the interview process.
The program was the light at the end of the tunnel [for me], and I landed a job within 1 month”
Wei Yuan
Business And Data Analyst
“Before joining HiCounselor I felt like I was spinning my wheels. Applying to jobs online with no
networking and no focus.Thanks to HiCounselor's training and networking, I learned how to network
and turn leads into offers!”
EMIL JOSWIN
Software Engineer at Habu
“When it comes to HiCounselor, the biggest plus is that they will do the networking on your behalf,
which in my experience saved 95% of my time and energy. I was able to then channel my time and energy
into being prepared for interviews.”
To help us tailor your experience, please let us know
what
you're looking for :
How would you define yourself?
Looking for job opportunities or internships
What Job Roles you are interested in?(Select one or
more)
How many years of Professional Experience do you have?
(Select one)
Will you require visa sponsorship to work in US?
What is your location preference for the job
LinkedIn OR Resume
Based on your provided information, we can help you with
the following:
Join HiCounselor Career Accelerator Program, where
we will help you with interview preparation and
connecting with you the right job opportunities
Click
here to fill out the application on the next step.
HiCounselor Projects Platform:
Complete Real World Projects to help you learn and get
ready for the job you want and Build professional
portfolio.
Based on your provided information, we can help you with
the following:
Actively hiring companies in
HiCounselor partners with companies hiring in ,
Select this option to get redirected to see the job
opportunities in
HiCounselor Projects Platform:
Complete Real World Projects to help you learn and get
ready for the job you want and Build professional
portfolio.
Based on your provided information, we can help you with
the following:
We recommend you to attempt real world projects on
HiCounselor Projects platform to get ready for
internships.
Once you have your portfolio built, visit this
page, where
we have listed startups whom you can reach out for
internships.
https://discord.gg/GUPad7ETad